SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwrReparticiones
AS
SELECT     dbo.tb_Reparticiones.idReparticion AS ID, dbo.tb_Reparticiones.Reparticion AS Descripcion, dbo.tb_Reparticiones.EsEscuela, 
                      dbo.tb_Organizaciones.Nombre AS Organizacion
FROM         dbo.tb_Reparticiones left outer JOIN
                      dbo.tb_Organizaciones ON dbo.tb_Reparticiones.Organizacion = dbo.tb_Organizaciones.idOrganizaciones
GO
GRANT SELECT ON  [dbo].[vwrReparticiones] TO [CertificacionesServicios]
GRANT SELECT ON  [dbo].[vwrReparticiones] TO [GestionDeDocumentos]
GRANT SELECT ON  [dbo].[vwrReparticiones] TO [Informatica]
GRANT INSERT ON  [dbo].[vwrReparticiones] TO [Informatica]
GRANT DELETE ON  [dbo].[vwrReparticiones] TO [Informatica]
GRANT UPDATE ON  [dbo].[vwrReparticiones] TO [Informatica]
GRANT SELECT ON  [dbo].[vwrReparticiones] TO [SoloVer]
GO
